﻿CREATE TABLE [dbo].[Leads]
(
[LeadID] [int] NOT NULL IDENTITY(1, 1),
[SelPersonID] [varchar] (9) NULL,
[Zip] [varchar] (10) NULL,
[ZipRequesterCode] [varchar] (9) NULL,
[Division] [varchar] (2) NULL,
[Market] [varchar] (2) NULL,
[Territory] [varchar] (2) NULL,
[Zip4] [varchar] (4) NULL,
[CallType] [varchar] (1) NULL,
[LeadType] [varchar] (1) NULL,
[MdNumber] [varchar] (4) NULL,
[SequenceNumber] VARCHAR(9) NULL,
[RawData] text NULL,
[City] [varchar] (27) NULL,
[State] [varchar] (2) NULL,
[County] [varchar] (27) NULL,
[Latitude] [varchar] (9) NULL,
[Longitude] [varchar] (9) NULL,
[ProsLeadCount] [int] NULL,
[PcLeadType] [varchar] (1) NULL,
[PersonStatus] [varchar] (1) NULL,
[PreferCity] [varchar] (27) NULL,
) ON [PRIMARY]


